{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import rqdatac as rq\n",
    "from rqdatac import *\n",
    "rq.init()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>order_book_id</th>\n",
       "      <th>symbol</th>\n",
       "      <th>abbrev_symbol</th>\n",
       "      <th>type</th>\n",
       "      <th>listed_date</th>\n",
       "      <th>de_listed_date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>CF1909P13000</td>\n",
       "      <td>棉花1909沽13000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-15</td>\n",
       "      <td>2019-08-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>C2005C1940</td>\n",
       "      <td>玉米2005购1940</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-24</td>\n",
       "      <td>2020-04-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>C1909C1900</td>\n",
       "      <td>玉米1909购1900</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-01-28</td>\n",
       "      <td>2019-08-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>M1911C2900</td>\n",
       "      <td>豆粕1911购2900</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2018-11-16</td>\n",
       "      <td>2019-10-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>RU1909P12250</td>\n",
       "      <td>天然橡胶1909沽12250</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-01-28</td>\n",
       "      <td>2019-08-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>RU1910C10000</td>\n",
       "      <td>天然橡胶1910购10000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>2019-09-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>RU1911C11000</td>\n",
       "      <td>天然橡胶1911购11000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-01-28</td>\n",
       "      <td>2019-10-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>RU1909P14500</td>\n",
       "      <td>天然橡胶1909沽14500</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-02-26</td>\n",
       "      <td>2019-08-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SR2005C5000</td>\n",
       "      <td>白糖2005购5000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-22</td>\n",
       "      <td>2020-04-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>CU2003C48000</td>\n",
       "      <td>铜2003购48000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-03-18</td>\n",
       "      <td>2020-02-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>SR2003P5000</td>\n",
       "      <td>白糖2003沽5000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-23</td>\n",
       "      <td>2020-02-05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>CF2005C13200</td>\n",
       "      <td>棉花2005购13200</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-28</td>\n",
       "      <td>2020-04-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>SR1911C5200</td>\n",
       "      <td>白糖1911购5200</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-01-16</td>\n",
       "      <td>2019-10-10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>M1911P2850</td>\n",
       "      <td>豆粕1911沽2850</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2018-11-16</td>\n",
       "      <td>2019-10-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>CU2003C52000</td>\n",
       "      <td>铜2003购52000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-03-18</td>\n",
       "      <td>2020-02-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>M1909C2800</td>\n",
       "      <td>豆粕1909购2800</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2018-09-18</td>\n",
       "      <td>2019-08-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>RU1910C11500</td>\n",
       "      <td>天然橡胶1910购11500</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-01-28</td>\n",
       "      <td>2019-09-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CU2004P47000</td>\n",
       "      <td>铜2004沽47000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-04-16</td>\n",
       "      <td>2020-03-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>RU1909P11000</td>\n",
       "      <td>天然橡胶1909沽11000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-01-28</td>\n",
       "      <td>2019-08-26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>CF2005C15200</td>\n",
       "      <td>棉花2005购15200</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-28</td>\n",
       "      <td>2020-04-03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>RU2005P12500</td>\n",
       "      <td>天然橡胶2005沽12500</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-16</td>\n",
       "      <td>2020-04-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>RU2004P14000</td>\n",
       "      <td>天然橡胶2004沽14000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-04-16</td>\n",
       "      <td>2020-03-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>M1912P3150</td>\n",
       "      <td>豆粕1912沽3150</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-30</td>\n",
       "      <td>2019-11-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>CF2001P17400</td>\n",
       "      <td>棉花2001沽17400</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-02-22</td>\n",
       "      <td>2019-12-04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>C1911C2080</td>\n",
       "      <td>玉米1911购2080</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-02-01</td>\n",
       "      <td>2019-10-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>M2005P3050</td>\n",
       "      <td>豆粕2005沽3050</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-30</td>\n",
       "      <td>2020-04-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>C2001P2180</td>\n",
       "      <td>玉米2001沽2180</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-05-21</td>\n",
       "      <td>2019-12-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>CU2003P46000</td>\n",
       "      <td>铜2003沽46000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-03-18</td>\n",
       "      <td>2020-02-24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CU2004C47000</td>\n",
       "      <td>铜2004购47000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-04-16</td>\n",
       "      <td>2020-03-25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>C1909C1800</td>\n",
       "      <td>玉米1909购1800</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-01-28</td>\n",
       "      <td>2019-08-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18666</th>\n",
       "      <td>EB99</td>\n",
       "      <td>苯乙烯指数连续</td>\n",
       "      <td>None</td>\n",
       "      <td>Future</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>0000-00-00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18667</th>\n",
       "      <td>EB888</td>\n",
       "      <td>苯乙烯主力连续价差平滑</td>\n",
       "      <td>None</td>\n",
       "      <td>Future</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>0000-00-00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18668</th>\n",
       "      <td>C2003P1740</td>\n",
       "      <td>玉米2003沽1740</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-27</td>\n",
       "      <td>2020-02-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18669</th>\n",
       "      <td>C2005P1780</td>\n",
       "      <td>玉米2005沽1780</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-27</td>\n",
       "      <td>2020-04-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18670</th>\n",
       "      <td>C2001C1720</td>\n",
       "      <td>玉米2001购1720</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-27</td>\n",
       "      <td>2019-12-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18671</th>\n",
       "      <td>C2001P1720</td>\n",
       "      <td>玉米2001沽1720</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-27</td>\n",
       "      <td>2019-12-06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18672</th>\n",
       "      <td>C2005C1780</td>\n",
       "      <td>玉米2005购1780</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-27</td>\n",
       "      <td>2020-04-09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18673</th>\n",
       "      <td>C2003C1740</td>\n",
       "      <td>玉米2003购1740</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-27</td>\n",
       "      <td>2020-02-07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18674</th>\n",
       "      <td>C1911P1700</td>\n",
       "      <td>玉米1911沽1700</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-27</td>\n",
       "      <td>2019-10-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18675</th>\n",
       "      <td>C1911C1700</td>\n",
       "      <td>玉米1911购1700</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-27</td>\n",
       "      <td>2019-10-14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18676</th>\n",
       "      <td>10001961</td>\n",
       "      <td>510050C1911M02800</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18677</th>\n",
       "      <td>10001962</td>\n",
       "      <td>510050C1911M02850</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18678</th>\n",
       "      <td>10001963</td>\n",
       "      <td>510050C1911M02900</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18679</th>\n",
       "      <td>10001964</td>\n",
       "      <td>510050C1911M02950</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18680</th>\n",
       "      <td>10001965</td>\n",
       "      <td>510050C1911M03000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18681</th>\n",
       "      <td>10001966</td>\n",
       "      <td>510050C1911M03100</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18682</th>\n",
       "      <td>10001967</td>\n",
       "      <td>510050C1911M03200</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18683</th>\n",
       "      <td>10001968</td>\n",
       "      <td>510050C1911M03300</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18684</th>\n",
       "      <td>10001969</td>\n",
       "      <td>510050C1911M03400</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18685</th>\n",
       "      <td>10001970</td>\n",
       "      <td>510050P1911M02800</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18686</th>\n",
       "      <td>10001971</td>\n",
       "      <td>510050P1911M02850</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18687</th>\n",
       "      <td>10001972</td>\n",
       "      <td>510050P1911M02900</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18688</th>\n",
       "      <td>10001973</td>\n",
       "      <td>510050P1911M02950</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18689</th>\n",
       "      <td>10001974</td>\n",
       "      <td>510050P1911M03000</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18690</th>\n",
       "      <td>10001975</td>\n",
       "      <td>510050P1911M03100</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18691</th>\n",
       "      <td>10001976</td>\n",
       "      <td>510050P1911M03200</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18692</th>\n",
       "      <td>10001977</td>\n",
       "      <td>510050P1911M03300</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18693</th>\n",
       "      <td>10001978</td>\n",
       "      <td>510050P1911M03400</td>\n",
       "      <td>None</td>\n",
       "      <td>Option</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>2019-11-27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18694</th>\n",
       "      <td>501089.XSHG</td>\n",
       "      <td>方正消费红利</td>\n",
       "      <td>FZXFHL</td>\n",
       "      <td>LOF</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>0000-00-00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18695</th>\n",
       "      <td>501090.XSHG</td>\n",
       "      <td>华宝中证消费</td>\n",
       "      <td>HBZZXF</td>\n",
       "      <td>LOF</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>0000-00-00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>18696 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      order_book_id             symbol abbrev_symbol    type listed_date  \\\n",
       "0      CF1909P13000       棉花1909沽13000          None  Option  2019-05-15   \n",
       "1        C2005C1940        玉米2005购1940          None  Option  2019-05-24   \n",
       "2        C1909C1900        玉米1909购1900          None  Option  2019-01-28   \n",
       "3        M1911C2900        豆粕1911购2900          None  Option  2018-11-16   \n",
       "4      RU1909P12250     天然橡胶1909沽12250          None  Option  2019-01-28   \n",
       "5      RU1910C10000     天然橡胶1910购10000          None  Option  2019-02-01   \n",
       "6      RU1911C11000     天然橡胶1911购11000          None  Option  2019-01-28   \n",
       "7      RU1909P14500     天然橡胶1909沽14500          None  Option  2019-02-26   \n",
       "8       SR2005C5000        白糖2005购5000          None  Option  2019-05-22   \n",
       "9      CU2003C48000        铜2003购48000          None  Option  2019-03-18   \n",
       "10      SR2003P5000        白糖2003沽5000          None  Option  2019-05-23   \n",
       "11     CF2005C13200       棉花2005购13200          None  Option  2019-05-28   \n",
       "12      SR1911C5200        白糖1911购5200          None  Option  2019-01-16   \n",
       "13       M1911P2850        豆粕1911沽2850          None  Option  2018-11-16   \n",
       "14     CU2003C52000        铜2003购52000          None  Option  2019-03-18   \n",
       "15       M1909C2800        豆粕1909购2800          None  Option  2018-09-18   \n",
       "16     RU1910C11500     天然橡胶1910购11500          None  Option  2019-01-28   \n",
       "17     CU2004P47000        铜2004沽47000          None  Option  2019-04-16   \n",
       "18     RU1909P11000     天然橡胶1909沽11000          None  Option  2019-01-28   \n",
       "19     CF2005C15200       棉花2005购15200          None  Option  2019-05-28   \n",
       "20     RU2005P12500     天然橡胶2005沽12500          None  Option  2019-05-16   \n",
       "21     RU2004P14000     天然橡胶2004沽14000          None  Option  2019-04-16   \n",
       "22       M1912P3150        豆粕1912沽3150          None  Option  2019-05-30   \n",
       "23     CF2001P17400       棉花2001沽17400          None  Option  2019-02-22   \n",
       "24       C1911C2080        玉米1911购2080          None  Option  2019-02-01   \n",
       "25       M2005P3050        豆粕2005沽3050          None  Option  2019-05-30   \n",
       "26       C2001P2180        玉米2001沽2180          None  Option  2019-05-21   \n",
       "27     CU2003P46000        铜2003沽46000          None  Option  2019-03-18   \n",
       "28     CU2004C47000        铜2004购47000          None  Option  2019-04-16   \n",
       "29       C1909C1800        玉米1909购1800          None  Option  2019-01-28   \n",
       "...             ...                ...           ...     ...         ...   \n",
       "18666          EB99            苯乙烯指数连续          None  Future  0000-00-00   \n",
       "18667         EB888        苯乙烯主力连续价差平滑          None  Future  0000-00-00   \n",
       "18668    C2003P1740        玉米2003沽1740          None  Option  2019-09-27   \n",
       "18669    C2005P1780        玉米2005沽1780          None  Option  2019-09-27   \n",
       "18670    C2001C1720        玉米2001购1720          None  Option  2019-09-27   \n",
       "18671    C2001P1720        玉米2001沽1720          None  Option  2019-09-27   \n",
       "18672    C2005C1780        玉米2005购1780          None  Option  2019-09-27   \n",
       "18673    C2003C1740        玉米2003购1740          None  Option  2019-09-27   \n",
       "18674    C1911P1700        玉米1911沽1700          None  Option  2019-09-27   \n",
       "18675    C1911C1700        玉米1911购1700          None  Option  2019-09-27   \n",
       "18676      10001961  510050C1911M02800          None  Option  2019-09-26   \n",
       "18677      10001962  510050C1911M02850          None  Option  2019-09-26   \n",
       "18678      10001963  510050C1911M02900          None  Option  2019-09-26   \n",
       "18679      10001964  510050C1911M02950          None  Option  2019-09-26   \n",
       "18680      10001965  510050C1911M03000          None  Option  2019-09-26   \n",
       "18681      10001966  510050C1911M03100          None  Option  2019-09-26   \n",
       "18682      10001967  510050C1911M03200          None  Option  2019-09-26   \n",
       "18683      10001968  510050C1911M03300          None  Option  2019-09-26   \n",
       "18684      10001969  510050C1911M03400          None  Option  2019-09-26   \n",
       "18685      10001970  510050P1911M02800          None  Option  2019-09-26   \n",
       "18686      10001971  510050P1911M02850          None  Option  2019-09-26   \n",
       "18687      10001972  510050P1911M02900          None  Option  2019-09-26   \n",
       "18688      10001973  510050P1911M02950          None  Option  2019-09-26   \n",
       "18689      10001974  510050P1911M03000          None  Option  2019-09-26   \n",
       "18690      10001975  510050P1911M03100          None  Option  2019-09-26   \n",
       "18691      10001976  510050P1911M03200          None  Option  2019-09-26   \n",
       "18692      10001977  510050P1911M03300          None  Option  2019-09-26   \n",
       "18693      10001978  510050P1911M03400          None  Option  2019-09-26   \n",
       "18694   501089.XSHG             方正消费红利        FZXFHL     LOF  2999-12-31   \n",
       "18695   501090.XSHG             华宝中证消费        HBZZXF     LOF  2999-12-31   \n",
       "\n",
       "      de_listed_date  \n",
       "0         2019-08-05  \n",
       "1         2020-04-09  \n",
       "2         2019-08-07  \n",
       "3         2019-10-14  \n",
       "4         2019-08-26  \n",
       "5         2019-09-24  \n",
       "6         2019-10-25  \n",
       "7         2019-08-26  \n",
       "8         2020-04-03  \n",
       "9         2020-02-24  \n",
       "10        2020-02-05  \n",
       "11        2020-04-03  \n",
       "12        2019-10-10  \n",
       "13        2019-10-14  \n",
       "14        2020-02-24  \n",
       "15        2019-08-07  \n",
       "16        2019-09-24  \n",
       "17        2020-03-25  \n",
       "18        2019-08-26  \n",
       "19        2020-04-03  \n",
       "20        2020-04-24  \n",
       "21        2020-03-25  \n",
       "22        2019-11-07  \n",
       "23        2019-12-04  \n",
       "24        2019-10-14  \n",
       "25        2020-04-09  \n",
       "26        2019-12-06  \n",
       "27        2020-02-24  \n",
       "28        2020-03-25  \n",
       "29        2019-08-07  \n",
       "...              ...  \n",
       "18666     0000-00-00  \n",
       "18667     0000-00-00  \n",
       "18668     2020-02-07  \n",
       "18669     2020-04-09  \n",
       "18670     2019-12-06  \n",
       "18671     2019-12-06  \n",
       "18672     2020-04-09  \n",
       "18673     2020-02-07  \n",
       "18674     2019-10-14  \n",
       "18675     2019-10-14  \n",
       "18676     2019-11-27  \n",
       "18677     2019-11-27  \n",
       "18678     2019-11-27  \n",
       "18679     2019-11-27  \n",
       "18680     2019-11-27  \n",
       "18681     2019-11-27  \n",
       "18682     2019-11-27  \n",
       "18683     2019-11-27  \n",
       "18684     2019-11-27  \n",
       "18685     2019-11-27  \n",
       "18686     2019-11-27  \n",
       "18687     2019-11-27  \n",
       "18688     2019-11-27  \n",
       "18689     2019-11-27  \n",
       "18690     2019-11-27  \n",
       "18691     2019-11-27  \n",
       "18692     2019-11-27  \n",
       "18693     2019-11-27  \n",
       "18694     0000-00-00  \n",
       "18695     0000-00-00  \n",
       "\n",
       "[18696 rows x 6 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 获取中国市场所有合约的基础信息\n",
    "rq.all_instruments()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>abbrev_symbol</th>\n",
       "      <th>de_listed_date</th>\n",
       "      <th>establishment_date</th>\n",
       "      <th>exchange</th>\n",
       "      <th>listed_date</th>\n",
       "      <th>market_tplus</th>\n",
       "      <th>order_book_id</th>\n",
       "      <th>round_lot</th>\n",
       "      <th>status</th>\n",
       "      <th>symbol</th>\n",
       "      <th>trading_hours</th>\n",
       "      <th>type</th>\n",
       "      <th>underlying_name</th>\n",
       "      <th>underlying_order_book_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>GTRFJQ</td>\n",
       "      <td>2015-08-14</td>\n",
       "      <td>2012-07-17</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2012-08-17</td>\n",
       "      <td>1</td>\n",
       "      <td>150001.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>国投瑞福进取</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>YHXFB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2011-09-28</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2011-10-21</td>\n",
       "      <td>1</td>\n",
       "      <td>150048.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>银华消费B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>GFYLLA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2012-05-07</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2012-06-12</td>\n",
       "      <td>1</td>\n",
       "      <td>150083.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>广发100A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>ZSSPA</td>\n",
       "      <td>2017-06-29</td>\n",
       "      <td>2012-06-28</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2012-07-25</td>\n",
       "      <td>1</td>\n",
       "      <td>150096.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>招商商品A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>JXWLA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2013-03-28</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2013-05-20</td>\n",
       "      <td>1</td>\n",
       "      <td>150123.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>建信50A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>YHBLLB</td>\n",
       "      <td>2019-04-16</td>\n",
       "      <td>2013-11-05</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2013-12-11</td>\n",
       "      <td>1</td>\n",
       "      <td>150139.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>银华800B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>FGCYBB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2013-09-12</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2013-09-30</td>\n",
       "      <td>1</td>\n",
       "      <td>150153.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>富国创业板B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>DWZZA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2014-05-09</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2014-06-06</td>\n",
       "      <td>1</td>\n",
       "      <td>150164.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>东吴转债A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>GTYSA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-03-30</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-04-15</td>\n",
       "      <td>1</td>\n",
       "      <td>150196.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>国泰有色A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>GTCYB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-03-17</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-03-27</td>\n",
       "      <td>1</td>\n",
       "      <td>150214.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>国投创业B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>FGYHB</td>\n",
       "      <td>2019-05-10</td>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-05-13</td>\n",
       "      <td>1</td>\n",
       "      <td>150242.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>富国银行B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>ZSMTB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-05-20</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-05-28</td>\n",
       "      <td>1</td>\n",
       "      <td>150252.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>招商煤炭B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>ZRGTA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-06-19</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-06-29</td>\n",
       "      <td>1</td>\n",
       "      <td>150287.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>中融钢铁A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>ZRGTB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-06-19</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-06-29</td>\n",
       "      <td>1</td>\n",
       "      <td>150288.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>中融钢铁B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>HAZQB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-06-09</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-06-18</td>\n",
       "      <td>1</td>\n",
       "      <td>150302.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>华安证券B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>DCDCL</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2018-08-18</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2018-08-18</td>\n",
       "      <td>1</td>\n",
       "      <td>160921.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>大成多策略</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>ZSZR</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2017-12-02</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2017-12-02</td>\n",
       "      <td>1</td>\n",
       "      <td>161727.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>招商增荣</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>YHHB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>1</td>\n",
       "      <td>161836.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>银华惠博</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>GYSZ</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2016-09-26</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2016-09-26</td>\n",
       "      <td>1</td>\n",
       "      <td>164814.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>工银双债</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>PYWJC</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2014-12-16</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-01-08</td>\n",
       "      <td>1</td>\n",
       "      <td>166401.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>浦银稳健C</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>DFHRY</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2019-01-16</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2019-01-16</td>\n",
       "      <td>1</td>\n",
       "      <td>169102.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>东方红睿阳</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>JJTY</td>\n",
       "      <td>2014-04-04</td>\n",
       "      <td>1999-04-08</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>1999-04-21</td>\n",
       "      <td>1</td>\n",
       "      <td>184690.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>基金同益</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>JJYZ</td>\n",
       "      <td>2011-04-22</td>\n",
       "      <td>2000-03-27</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2000-05-17</td>\n",
       "      <td>1</td>\n",
       "      <td>184705.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>基金裕泽</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>JXYS</td>\n",
       "      <td>2013-03-18</td>\n",
       "      <td>2008-03-19</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2008-09-19</td>\n",
       "      <td>1</td>\n",
       "      <td>150003.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>建信优势</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>JJXA</td>\n",
       "      <td>2007-11-22</td>\n",
       "      <td>2000-07-20</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2000-09-20</td>\n",
       "      <td>1</td>\n",
       "      <td>184718.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>基金兴安</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>JJJY</td>\n",
       "      <td>2007-12-11</td>\n",
       "      <td>1999-09-17</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>1999-10-22</td>\n",
       "      <td>1</td>\n",
       "      <td>500007.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>基金景阳</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BSYXB</td>\n",
       "      <td>2014-06-10</td>\n",
       "      <td>2011-06-10</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2011-09-02</td>\n",
       "      <td>1</td>\n",
       "      <td>150043.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>博时裕祥B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>HTFWLLC</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2017-08-10</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2017-10-09</td>\n",
       "      <td>1</td>\n",
       "      <td>501037.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>汇添富500C</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>中证小盘500指数</td>\n",
       "      <td>000905.XSHG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>SWZXBA</td>\n",
       "      <td>2017-05-08</td>\n",
       "      <td>2012-05-08</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2012-05-28</td>\n",
       "      <td>1</td>\n",
       "      <td>150085.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>申万中小板A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>WJZCA</td>\n",
       "      <td>2018-08-14</td>\n",
       "      <td>2012-08-02</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2012-10-12</td>\n",
       "      <td>1</td>\n",
       "      <td>150090.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>万家中创A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>758</th>\n",
       "      <td>ZRMTB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-06-25</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-07-03</td>\n",
       "      <td>1</td>\n",
       "      <td>150290.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>中融煤炭B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>759</th>\n",
       "      <td>FGMTB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-06-19</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-06-30</td>\n",
       "      <td>1</td>\n",
       "      <td>150322.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>富国煤炭B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>760</th>\n",
       "      <td>NFJLA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2013-11-28</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2014-01-21</td>\n",
       "      <td>1</td>\n",
       "      <td>160131.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>南方聚利A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761</th>\n",
       "      <td>CSTF</td>\n",
       "      <td>2018-01-23</td>\n",
       "      <td>2012-12-27</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2014-07-11</td>\n",
       "      <td>1</td>\n",
       "      <td>160810.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>长盛同丰</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762</th>\n",
       "      <td>DCJF</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2010-10-15</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2013-12-02</td>\n",
       "      <td>1</td>\n",
       "      <td>160915.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>大成景丰</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>DCZXP</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2014-04-10</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2014-04-30</td>\n",
       "      <td>1</td>\n",
       "      <td>160918.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>大成中小盘</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>DCCY</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2014-12-26</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-01-09</td>\n",
       "      <td>1</td>\n",
       "      <td>160919.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>大成产业</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765</th>\n",
       "      <td>FGWLL</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2011-10-12</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2011-10-21</td>\n",
       "      <td>1</td>\n",
       "      <td>161017.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>富国500</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>中证小盘500指数</td>\n",
       "      <td>000905.XSHG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>766</th>\n",
       "      <td>RTJCAB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2005-05-12</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2005-06-16</td>\n",
       "      <td>1</td>\n",
       "      <td>161607.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>融通巨潮A/B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>巨潮100指数</td>\n",
       "      <td>399313.XSHE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>767</th>\n",
       "      <td>ZSSZC</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-03-02</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2015-03-16</td>\n",
       "      <td>1</td>\n",
       "      <td>161716.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>招商双债C</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>768</th>\n",
       "      <td>TZHX</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2006-01-20</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2007-07-30</td>\n",
       "      <td>1</td>\n",
       "      <td>163503.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>天治核心</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>769</th>\n",
       "      <td>GYSJ</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2011-02-10</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2011-03-28</td>\n",
       "      <td>1</td>\n",
       "      <td>164808.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>工银四季</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>770</th>\n",
       "      <td>ZS300</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2018-08-20</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>1</td>\n",
       "      <td>166802.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>浙商300</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>沪深300指数</td>\n",
       "      <td>399300.XSHE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771</th>\n",
       "      <td>JTRY</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2016-08-11</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2016-11-23</td>\n",
       "      <td>1</td>\n",
       "      <td>168103.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>九泰锐益</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>772</th>\n",
       "      <td>JTYHA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2018-12-19</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2018-12-19</td>\n",
       "      <td>1</td>\n",
       "      <td>168106.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>九泰盈华A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>773</th>\n",
       "      <td>JJLY</td>\n",
       "      <td>2007-11-09</td>\n",
       "      <td>2000-07-24</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2000-10-18</td>\n",
       "      <td>1</td>\n",
       "      <td>184710.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>基金隆元</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>774</th>\n",
       "      <td>JJTB</td>\n",
       "      <td>2007-04-30</td>\n",
       "      <td>2001-05-16</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2001-09-06</td>\n",
       "      <td>1</td>\n",
       "      <td>184738.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Delisted</td>\n",
       "      <td>基金通宝</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>775</th>\n",
       "      <td>YFDQGA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-06-15</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2015-06-25</td>\n",
       "      <td>1</td>\n",
       "      <td>502007.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>易方达企改A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>776</th>\n",
       "      <td>PHGTA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-08-13</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2015-08-24</td>\n",
       "      <td>1</td>\n",
       "      <td>502024.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>鹏华钢铁A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>777</th>\n",
       "      <td>CSWLB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2015-08-13</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2015-08-24</td>\n",
       "      <td>1</td>\n",
       "      <td>502042.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>长盛50B</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>778</th>\n",
       "      <td>YHHA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2017-03-17</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>1</td>\n",
       "      <td>501033.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>银华惠安</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>779</th>\n",
       "      <td>CTZG500A</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2019-06-27</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2019-07-31</td>\n",
       "      <td>1</td>\n",
       "      <td>169301.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>财通资管500A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>中证小盘500指数</td>\n",
       "      <td>399905.XSHE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>780</th>\n",
       "      <td>GFRY</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2019-01-31</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2019-07-31</td>\n",
       "      <td>1</td>\n",
       "      <td>501070.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Active</td>\n",
       "      <td>广发睿阳</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>781</th>\n",
       "      <td>JSRH</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2019-09-04</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>1</td>\n",
       "      <td>501088.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>嘉实瑞虹</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>782</th>\n",
       "      <td>JYRF</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2019-09-04</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>1</td>\n",
       "      <td>501087.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>交银瑞丰</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>783</th>\n",
       "      <td>FZDWQZZ</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>1</td>\n",
       "      <td>167302.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>方正大湾区综指</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>784</th>\n",
       "      <td>XDDYZA</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>1</td>\n",
       "      <td>166107.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>信达多因子A</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>785</th>\n",
       "      <td>YFDZXB</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2019-09-20</td>\n",
       "      <td>XSHE</td>\n",
       "      <td>2019-10-09</td>\n",
       "      <td>1</td>\n",
       "      <td>161118.XSHE</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>易方达中小板</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>中小板指数(价格)</td>\n",
       "      <td>399005.XSHE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>786</th>\n",
       "      <td>FZXFHL</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>1</td>\n",
       "      <td>501089.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>方正消费红利</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>中证主要消费红利指数</td>\n",
       "      <td>H30094.XSHG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>787</th>\n",
       "      <td>HBZZXF</td>\n",
       "      <td>0000-00-00</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>XSHG</td>\n",
       "      <td>2999-12-31</td>\n",
       "      <td>1</td>\n",
       "      <td>501090.XSHG</td>\n",
       "      <td>100</td>\n",
       "      <td>Unknown</td>\n",
       "      <td>华宝中证消费</td>\n",
       "      <td>09:31-11:30,13:01-15:00</td>\n",
       "      <td>LOF</td>\n",
       "      <td>中证消费龙头指数</td>\n",
       "      <td>931068</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>788 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    abbrev_symbol de_listed_date establishment_date exchange listed_date  \\\n",
       "0          GTRFJQ     2015-08-14         2012-07-17     XSHE  2012-08-17   \n",
       "1           YHXFB     0000-00-00         2011-09-28     XSHE  2011-10-21   \n",
       "2          GFYLLA     0000-00-00         2012-05-07     XSHE  2012-06-12   \n",
       "3           ZSSPA     2017-06-29         2012-06-28     XSHE  2012-07-25   \n",
       "4           JXWLA     0000-00-00         2013-03-28     XSHE  2013-05-20   \n",
       "5          YHBLLB     2019-04-16         2013-11-05     XSHE  2013-12-11   \n",
       "6          FGCYBB     0000-00-00         2013-09-12     XSHE  2013-09-30   \n",
       "7           DWZZA     0000-00-00         2014-05-09     XSHE  2014-06-06   \n",
       "8           GTYSA     0000-00-00         2015-03-30     XSHE  2015-04-15   \n",
       "9           GTCYB     0000-00-00         2015-03-17     XSHE  2015-03-27   \n",
       "10          FGYHB     2019-05-10         2015-04-30     XSHE  2015-05-13   \n",
       "11          ZSMTB     0000-00-00         2015-05-20     XSHE  2015-05-28   \n",
       "12          ZRGTA     0000-00-00         2015-06-19     XSHE  2015-06-29   \n",
       "13          ZRGTB     0000-00-00         2015-06-19     XSHE  2015-06-29   \n",
       "14          HAZQB     0000-00-00         2015-06-09     XSHE  2015-06-18   \n",
       "15          DCDCL     0000-00-00         2018-08-18     XSHE  2018-08-18   \n",
       "16           ZSZR     0000-00-00         2017-12-02     XSHE  2017-12-02   \n",
       "17           YHHB     0000-00-00         2999-12-31     XSHE  2999-12-31   \n",
       "18           GYSZ     0000-00-00         2016-09-26     XSHE  2016-09-26   \n",
       "19          PYWJC     0000-00-00         2014-12-16     XSHE  2015-01-08   \n",
       "20          DFHRY     0000-00-00         2019-01-16     XSHE  2019-01-16   \n",
       "21           JJTY     2014-04-04         1999-04-08     XSHE  1999-04-21   \n",
       "22           JJYZ     2011-04-22         2000-03-27     XSHE  2000-05-17   \n",
       "23           JXYS     2013-03-18         2008-03-19     XSHE  2008-09-19   \n",
       "24           JJXA     2007-11-22         2000-07-20     XSHE  2000-09-20   \n",
       "25           JJJY     2007-12-11         1999-09-17     XSHG  1999-10-22   \n",
       "26          BSYXB     2014-06-10         2011-06-10     XSHE  2011-09-02   \n",
       "27        HTFWLLC     0000-00-00         2017-08-10     XSHG  2017-10-09   \n",
       "28         SWZXBA     2017-05-08         2012-05-08     XSHE  2012-05-28   \n",
       "29          WJZCA     2018-08-14         2012-08-02     XSHE  2012-10-12   \n",
       "..            ...            ...                ...      ...         ...   \n",
       "758         ZRMTB     0000-00-00         2015-06-25     XSHE  2015-07-03   \n",
       "759         FGMTB     0000-00-00         2015-06-19     XSHE  2015-06-30   \n",
       "760         NFJLA     0000-00-00         2013-11-28     XSHE  2014-01-21   \n",
       "761          CSTF     2018-01-23         2012-12-27     XSHE  2014-07-11   \n",
       "762          DCJF     0000-00-00         2010-10-15     XSHE  2013-12-02   \n",
       "763         DCZXP     0000-00-00         2014-04-10     XSHE  2014-04-30   \n",
       "764          DCCY     0000-00-00         2014-12-26     XSHE  2015-01-09   \n",
       "765         FGWLL     0000-00-00         2011-10-12     XSHE  2011-10-21   \n",
       "766        RTJCAB     0000-00-00         2005-05-12     XSHE  2005-06-16   \n",
       "767         ZSSZC     0000-00-00         2015-03-02     XSHE  2015-03-16   \n",
       "768          TZHX     0000-00-00         2006-01-20     XSHE  2007-07-30   \n",
       "769          GYSJ     0000-00-00         2011-02-10     XSHE  2011-03-28   \n",
       "770         ZS300     0000-00-00         2018-08-20     XSHE  2999-12-31   \n",
       "771          JTRY     0000-00-00         2016-08-11     XSHE  2016-11-23   \n",
       "772         JTYHA     0000-00-00         2018-12-19     XSHE  2018-12-19   \n",
       "773          JJLY     2007-11-09         2000-07-24     XSHE  2000-10-18   \n",
       "774          JJTB     2007-04-30         2001-05-16     XSHE  2001-09-06   \n",
       "775        YFDQGA     0000-00-00         2015-06-15     XSHG  2015-06-25   \n",
       "776         PHGTA     0000-00-00         2015-08-13     XSHG  2015-08-24   \n",
       "777         CSWLB     0000-00-00         2015-08-13     XSHG  2015-08-24   \n",
       "778          YHHA     0000-00-00         2017-03-17     XSHG  2999-12-31   \n",
       "779      CTZG500A     0000-00-00         2019-06-27     XSHE  2019-07-31   \n",
       "780          GFRY     0000-00-00         2019-01-31     XSHG  2019-07-31   \n",
       "781          JSRH     0000-00-00         2019-09-04     XSHG  2999-12-31   \n",
       "782          JYRF     0000-00-00         2019-09-04     XSHG  2999-12-31   \n",
       "783       FZDWQZZ     0000-00-00         2019-09-26     XSHE  2999-12-31   \n",
       "784        XDDYZA     0000-00-00         2999-12-31     XSHE  2999-12-31   \n",
       "785        YFDZXB     0000-00-00         2019-09-20     XSHE  2019-10-09   \n",
       "786        FZXFHL     0000-00-00         2999-12-31     XSHG  2999-12-31   \n",
       "787        HBZZXF     0000-00-00         2999-12-31     XSHG  2999-12-31   \n",
       "\n",
       "     market_tplus order_book_id  round_lot    status    symbol  \\\n",
       "0               1   150001.XSHE        100  Delisted    国投瑞福进取   \n",
       "1               1   150048.XSHE        100    Active     银华消费B   \n",
       "2               1   150083.XSHE        100    Active    广发100A   \n",
       "3               1   150096.XSHE        100  Delisted     招商商品A   \n",
       "4               1   150123.XSHE        100    Active     建信50A   \n",
       "5               1   150139.XSHE        100  Delisted    银华800B   \n",
       "6               1   150153.XSHE        100    Active    富国创业板B   \n",
       "7               1   150164.XSHE        100    Active     东吴转债A   \n",
       "8               1   150196.XSHE        100    Active     国泰有色A   \n",
       "9               1   150214.XSHE        100    Active     国投创业B   \n",
       "10              1   150242.XSHE        100  Delisted     富国银行B   \n",
       "11              1   150252.XSHE        100    Active     招商煤炭B   \n",
       "12              1   150287.XSHE        100    Active     中融钢铁A   \n",
       "13              1   150288.XSHE        100    Active     中融钢铁B   \n",
       "14              1   150302.XSHE        100    Active     华安证券B   \n",
       "15              1   160921.XSHE        100    Active     大成多策略   \n",
       "16              1   161727.XSHE        100    Active      招商增荣   \n",
       "17              1   161836.XSHE        100   Unknown      银华惠博   \n",
       "18              1   164814.XSHE        100    Active      工银双债   \n",
       "19              1   166401.XSHE        100    Active     浦银稳健C   \n",
       "20              1   169102.XSHE        100    Active     东方红睿阳   \n",
       "21              1   184690.XSHE        100  Delisted      基金同益   \n",
       "22              1   184705.XSHE        100  Delisted      基金裕泽   \n",
       "23              1   150003.XSHE        100  Delisted      建信优势   \n",
       "24              1   184718.XSHE        100  Delisted      基金兴安   \n",
       "25              1   500007.XSHG        100  Delisted      基金景阳   \n",
       "26              1   150043.XSHE        100  Delisted     博时裕祥B   \n",
       "27              1   501037.XSHG        100    Active   汇添富500C   \n",
       "28              1   150085.XSHE        100  Delisted    申万中小板A   \n",
       "29              1   150090.XSHE        100  Delisted     万家中创A   \n",
       "..            ...           ...        ...       ...       ...   \n",
       "758             1   150290.XSHE        100    Active     中融煤炭B   \n",
       "759             1   150322.XSHE        100    Active     富国煤炭B   \n",
       "760             1   160131.XSHE        100    Active     南方聚利A   \n",
       "761             1   160810.XSHE        100  Delisted      长盛同丰   \n",
       "762             1   160915.XSHE        100    Active      大成景丰   \n",
       "763             1   160918.XSHE        100    Active     大成中小盘   \n",
       "764             1   160919.XSHE        100    Active      大成产业   \n",
       "765             1   161017.XSHE        100    Active     富国500   \n",
       "766             1   161607.XSHE        100    Active   融通巨潮A/B   \n",
       "767             1   161716.XSHE        100    Active     招商双债C   \n",
       "768             1   163503.XSHE        100    Active      天治核心   \n",
       "769             1   164808.XSHE        100    Active      工银四季   \n",
       "770             1   166802.XSHE        100   Unknown     浙商300   \n",
       "771             1   168103.XSHE        100    Active      九泰锐益   \n",
       "772             1   168106.XSHE        100    Active     九泰盈华A   \n",
       "773             1   184710.XSHE        100  Delisted      基金隆元   \n",
       "774             1   184738.XSHE        100  Delisted      基金通宝   \n",
       "775             1   502007.XSHG        100    Active    易方达企改A   \n",
       "776             1   502024.XSHG        100    Active     鹏华钢铁A   \n",
       "777             1   502042.XSHG        100    Active     长盛50B   \n",
       "778             1   501033.XSHG        100   Unknown      银华惠安   \n",
       "779             1   169301.XSHE        100    Active  财通资管500A   \n",
       "780             1   501070.XSHG        100    Active      广发睿阳   \n",
       "781             1   501088.XSHG        100   Unknown      嘉实瑞虹   \n",
       "782             1   501087.XSHG        100   Unknown      交银瑞丰   \n",
       "783             1   167302.XSHE        100   Unknown   方正大湾区综指   \n",
       "784             1   166107.XSHE        100   Unknown    信达多因子A   \n",
       "785             1   161118.XSHE        100   Unknown    易方达中小板   \n",
       "786             1   501089.XSHG        100   Unknown    方正消费红利   \n",
       "787             1   501090.XSHG        100   Unknown    华宝中证消费   \n",
       "\n",
       "               trading_hours type underlying_name underlying_order_book_id  \n",
       "0    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "1    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "2    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "3    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "4    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "5    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "6    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "7    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "8    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "9    09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "10   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "11   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "12   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "13   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "14   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "15   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "16   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "17   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "18   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "19   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "20   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "21   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "22   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "23   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "24   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "25   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "26   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "27   09:31-11:30,13:01-15:00  LOF       中证小盘500指数              000905.XSHG  \n",
       "28   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "29   09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "..                       ...  ...             ...                      ...  \n",
       "758  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "759  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "760  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "761  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "762  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "763  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "764  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "765  09:31-11:30,13:01-15:00  LOF       中证小盘500指数              000905.XSHG  \n",
       "766  09:31-11:30,13:01-15:00  LOF         巨潮100指数              399313.XSHE  \n",
       "767  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "768  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "769  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "770  09:31-11:30,13:01-15:00  LOF         沪深300指数              399300.XSHE  \n",
       "771  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "772  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "773  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "774  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "775  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "776  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "777  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "778  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "779  09:31-11:30,13:01-15:00  LOF       中证小盘500指数              399905.XSHE  \n",
       "780  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "781  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "782  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "783  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "784  09:31-11:30,13:01-15:00  LOF            None                     None  \n",
       "785  09:31-11:30,13:01-15:00  LOF       中小板指数(价格)              399005.XSHE  \n",
       "786  09:31-11:30,13:01-15:00  LOF      中证主要消费红利指数              H30094.XSHG  \n",
       "787  09:31-11:30,13:01-15:00  LOF        中证消费龙头指数                   931068  \n",
       "\n",
       "[788 rows x 14 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 获取中国市场所有LOF基金的基础信息\n",
    "rq.all_instruments(type='LOF')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "E:\\Anaconda3\\lib\\site-packages\\rqdatac\\services\\financial.py:339: UserWarning: Panel is  removed after pandas version 0.25.0.the  default value of 'expect_df' will change to True in the future.\n",
      "  warnings.warn(\"Panel is  removed after pandas version 0.25.0.\"\n",
      "E:\\Anaconda3\\lib\\site-packages\\ipykernel_launcher.py:3: DeprecationWarning: \n",
      "Panel is deprecated and will be removed in a future version.\n",
      "The recommended way to represent these types of 3-dimensional data are with a MultiIndex on a DataFrame, via the Panel.to_frame() method\n",
      "Alternatively, you can use the xarray package http://xarray.pydata.org/en/stable/.\n",
      "Pandas provides a `.to_xarray()` method to help automate this conversion.\n",
      "\n",
      "  This is separate from the ipykernel package so we can avoid doing imports until\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>report_quarter</th>\n",
       "      <th>pe_ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2016-08-01</th>\n",
       "      <td>2016q1</td>\n",
       "      <td>7.0593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-04-29</th>\n",
       "      <td>2016q1</td>\n",
       "      <td>6.7755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2016-01-29</th>\n",
       "      <td>2015q3</td>\n",
       "      <td>6.5441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2015-10-29</th>\n",
       "      <td>2015q3</td>\n",
       "      <td>7.3809</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           report_quarter pe_ratio\n",
       "2016-08-01         2016q1   7.0593\n",
       "2016-04-29         2016q1   6.7755\n",
       "2016-01-29         2015q3   6.5441\n",
       "2015-10-29         2015q3   7.3809"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 获取某只股票2016年8月1日及以前4个季度的市盈率（pe_ratio）\n",
    "dp = rq.get_fundamentals(query(fundamentals.eod_derivative_indicator.pe_ratio).filter(fundamentals.stockcode == '000001.XSHE'), \n",
    "                         '2016-08-01','4q' ,report_quarter = True)\n",
    "dp.minor_xs('000001.XSHE')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "ename": "PermissionDenied",
     "evalue": "Not permit to run api fund.all_instruments",
     "output_type": "error",
     "traceback": [
      "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[1;31mPermissionDenied\u001b[0m                          Traceback (most recent call last)",
      "\u001b[1;32m<ipython-input-10-ff67a7ddeb35>\u001b[0m in \u001b[0;36m<module>\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mfund\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0minstruments\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m'050116'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\services\\fund.py\u001b[0m in \u001b[0;36minstruments\u001b[1;34m(order_book_ids, market)\u001b[0m\n\u001b[0;32m    117\u001b[0m     \u001b[0morder_book_ids\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mensure_list_of_string\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0morder_book_ids\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    118\u001b[0m     \u001b[1;32mif\u001b[0m \u001b[0mlen\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0morder_book_ids\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m==\u001b[0m \u001b[1;36m1\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 119\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0m_get_instrument\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0morder_book_ids\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    120\u001b[0m     \u001b[0md\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0m_all_instruments_dict\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmarket\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    121\u001b[0m     \u001b[1;32mreturn\u001b[0m \u001b[1;33m[\u001b[0m\u001b[0md\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mi\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[1;32min\u001b[0m \u001b[0morder_book_ids\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mi\u001b[0m \u001b[1;32min\u001b[0m \u001b[0md\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\services\\fund.py\u001b[0m in \u001b[0;36m_get_instrument\u001b[1;34m(order_book_id, market)\u001b[0m\n\u001b[0;32m     21\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     22\u001b[0m \u001b[1;32mdef\u001b[0m \u001b[0m_get_instrument\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0morder_book_id\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmarket\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m\"cn\"\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 23\u001b[1;33m     \u001b[0md\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0m_all_instruments_dict\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmarket\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     24\u001b[0m     \u001b[1;32mreturn\u001b[0m \u001b[0md\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0morder_book_id\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     25\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[1;34m(*args, **kwargs)\u001b[0m\n\u001b[0;32m    109\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mexpire_at\u001b[0m \u001b[1;33m>\u001b[0m \u001b[0mtime\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtime\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    110\u001b[0m                 \u001b[1;32mreturn\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 111\u001b[1;33m         \u001b[0mvalue\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0muser_function\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    112\u001b[0m         \u001b[0mcache\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mtime\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtime\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m+\u001b[0m \u001b[0mttl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    113\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\services\\fund.py\u001b[0m in \u001b[0;36m_all_instruments_dict\u001b[1;34m(market)\u001b[0m\n\u001b[0;32m     32\u001b[0m \u001b[1;33m@\u001b[0m\u001b[0mttl_cache\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m3\u001b[0m \u001b[1;33m*\u001b[0m \u001b[1;36m3600\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     33\u001b[0m \u001b[1;32mdef\u001b[0m \u001b[0m_all_instruments_dict\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmarket\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 34\u001b[1;33m     \u001b[0mall_list\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0m_all_instruments_list\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmarket\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     35\u001b[0m     \u001b[0md\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m{\u001b[0m\u001b[1;33m}\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     36\u001b[0m     \u001b[1;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mall_list\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\decorators.py\u001b[0m in \u001b[0;36mwrapper\u001b[1;34m(*args, **kwargs)\u001b[0m\n\u001b[0;32m    109\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mexpire_at\u001b[0m \u001b[1;33m>\u001b[0m \u001b[0mtime\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtime\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    110\u001b[0m                 \u001b[1;32mreturn\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 111\u001b[1;33m         \u001b[0mvalue\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0muser_function\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    112\u001b[0m         \u001b[0mcache\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m]\u001b[0m \u001b[1;33m=\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mtime\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtime\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;33m+\u001b[0m \u001b[0mttl\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    113\u001b[0m         \u001b[1;32mreturn\u001b[0m \u001b[0mvalue\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\services\\fund.py\u001b[0m in \u001b[0;36m_all_instruments_list\u001b[1;34m(market)\u001b[0m\n\u001b[0;32m     27\u001b[0m \u001b[1;33m@\u001b[0m\u001b[0mttl_cache\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m3\u001b[0m \u001b[1;33m*\u001b[0m \u001b[1;36m3600\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     28\u001b[0m \u001b[1;32mdef\u001b[0m \u001b[0m_all_instruments_list\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmarket\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 29\u001b[1;33m     \u001b[1;32mreturn\u001b[0m \u001b[1;33m[\u001b[0m\u001b[0mInstrument\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mi\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mfor\u001b[0m \u001b[0mi\u001b[0m \u001b[1;32min\u001b[0m \u001b[0mget_client\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;34m\"fund.all_instruments\"\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmarket\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     30\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     31\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\decorators.py\u001b[0m in \u001b[0;36mwrap\u001b[1;34m(*args, **kwargs)\u001b[0m\n\u001b[0;32m     57\u001b[0m             \u001b[1;32mwhile\u001b[0m \u001b[0mc\u001b[0m \u001b[1;33m>\u001b[0m \u001b[1;36m0\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     58\u001b[0m                 \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 59\u001b[1;33m                     \u001b[1;32mreturn\u001b[0m \u001b[0mfunc\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     60\u001b[0m                 \u001b[1;32mexcept\u001b[0m \u001b[0msuppress_exceptions\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     61\u001b[0m                     \u001b[0mc\u001b[0m \u001b[1;33m-=\u001b[0m \u001b[1;36m1\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\thread_local.py\u001b[0m in \u001b[0;36mexecute\u001b[1;34m(self, method, *args, **kwargs)\u001b[0m\n\u001b[0;32m     41\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mretry\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m3\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0msuppress_exceptions\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mconnection_error\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mGatewayError\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtimeout_error\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0msocket\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtimeout\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     42\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0mexecute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 43\u001b[1;33m         \u001b[1;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_execute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_get_connection\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     44\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     45\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mretry\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m3\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0msuppress_exceptions\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mconnection_error\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mGatewayError\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\thread_local.py\u001b[0m in \u001b[0;36m_execute\u001b[1;34m(self, conn, method, args, kwargs)\u001b[0m\n\u001b[0;32m     37\u001b[0m                 \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mreset\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     38\u001b[0m                 \u001b[0mconn\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mclose\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 39\u001b[1;33m             \u001b[1;32mraise\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     40\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     41\u001b[0m     \u001b[1;33m@\u001b[0m\u001b[0mretry\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;36m3\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0msuppress_exceptions\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mconnection_error\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mGatewayError\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mtimeout_error\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0msocket\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mtimeout\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\thread_local.py\u001b[0m in \u001b[0;36m_execute\u001b[1;34m(self, conn, method, args, kwargs)\u001b[0m\n\u001b[0;32m     32\u001b[0m     \u001b[1;32mdef\u001b[0m \u001b[0m_execute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mself\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mconn\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     33\u001b[0m         \u001b[1;32mtry\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m---> 34\u001b[1;33m             \u001b[1;32mreturn\u001b[0m \u001b[0mconn\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mexecute\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmethod\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m*\u001b[0m\u001b[0margs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m**\u001b[0m\u001b[0mkwargs\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m     35\u001b[0m         \u001b[1;32mexcept\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mKeyboardInterrupt\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mException\u001b[0m\u001b[1;33m)\u001b[0m \u001b[1;32mas\u001b[0m \u001b[0me\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m     36\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[0misinstance\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0me\u001b[0m\u001b[1;33m,\u001b[0m \u001b[1;33m(\u001b[0m\u001b[0mErrorFromBackend\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mGatewayError\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\connection.py\u001b[0m in \u001b[0;36mexecute\u001b[1;34m(self, method, *args, **kwargs)\u001b[0m\n\u001b[0;32m    130\u001b[0m         )\n\u001b[0;32m    131\u001b[0m         \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_socket\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0msendall\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mrequest_body\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 132\u001b[1;33m         \u001b[0mmsg_type\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mbody\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_read_one_packet\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    133\u001b[0m         \u001b[1;32mif\u001b[0m \u001b[0mmsg_type\u001b[0m \u001b[1;33m==\u001b[0m \u001b[0mMSG_TYPE\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mRESPONSE\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    134\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mbody\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;32mE:\\Anaconda3\\lib\\site-packages\\rqdatac\\connection.py\u001b[0m in \u001b[0;36m_read_one_packet\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m    100\u001b[0m             \u001b[1;32mif\u001b[0m \u001b[0mmt\u001b[0m \u001b[1;33m==\u001b[0m \u001b[0mMSG_TYPE\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mERROR\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    101\u001b[0m                 \u001b[0mcode\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mmsg\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mbody\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 102\u001b[1;33m                 \u001b[1;32mraise\u001b[0m \u001b[0mget_error\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mcode\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mmsg\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m    103\u001b[0m             \u001b[1;32mreturn\u001b[0m \u001b[0mmt\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mbody\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m    104\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n",
      "\u001b[1;31mPermissionDenied\u001b[0m: Not permit to run api fund.all_instruments"
     ]
    }
   ],
   "source": [
    "# 查询某基金合约信息\n",
    "fund.instruments('050116')"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### 查询某基金合约信息 -- 错误\n",
    "### 原因：（PermissionDenied: Not permit to run api fund.all_instruments"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
